UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1kVV+cz+AK4rk4iR4OzoVHf9Lx1CLqTcIgfbPKO1NQ='
WHERE
key_id = 'a700c6de73eb904aed5825618037799ab6ff57fac3a91908e42dee6197440286'
AND (
token = 'X1kVV+cz+AK4rk4iR4OzoVHf9Lx1CLqTcIgfbPKO1NQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)