UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCk9pLXzeuHmca4ERpbXavptOit1n5/3Wpr9eFvnp8Q='
WHERE
key_id = 'a4c16cac1c3abdeb022af0c6c795f57112541cb1d4c11a15046a36a9d8923e90'
AND (
token = 'YCk9pLXzeuHmca4ERpbXavptOit1n5/3Wpr9eFvnp8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)