UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7vP3hR2qQmEAINTsvZFMiyF5MtvS1sFXxQNt2zGt/Gg='
WHERE
key_id = 'bc4cabce9f2edc692b6651073cc00d92f0f1f4b9fca6a63cff7b712d200b77d1'
AND (
token = '7vP3hR2qQmEAINTsvZFMiyF5MtvS1sFXxQNt2zGt/Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)