UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hyyAGUaXtfDA7+vhc02dXE5wI1iuAYNSLywS9Kx8emI='
WHERE
key_id = 'fd3fe5a9b3b794793978bd9145ccdc5f110b7627cb55a104a3a6a473b8ce333a'
AND (
token = 'hyyAGUaXtfDA7+vhc02dXE5wI1iuAYNSLywS9Kx8emI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)