UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VU+CUytJzN6WlnxhHx33KgIjUKMkI08Q8WLtS4pKUII='
WHERE
key_id = 'cd4a8dbe9522ad14a31aa6a987d67a3c0a6d84510a7606e45fae77a598b4642f'
AND (
token = 'VU+CUytJzN6WlnxhHx33KgIjUKMkI08Q8WLtS4pKUII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)