UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q27ackiYfE9G2dqKZ+3Gwvo2qK6gvcbBfk1w84bKElU='
WHERE
key_id = '73abff157e72eebe371ce320e2f1b32418f0157b77c6316d30e9707fe12197f3'
AND (
token = 'q27ackiYfE9G2dqKZ+3Gwvo2qK6gvcbBfk1w84bKElU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)