UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4yPhOMQu2tjwRuBb6TwzlIKxTmTvF72lLLRPm8doHgA='
WHERE
key_id = '6da172547a1639639985f9cc4546f8606edfb971a74ed437f9ebb0aa694d4a50'
AND (
token = '4yPhOMQu2tjwRuBb6TwzlIKxTmTvF72lLLRPm8doHgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)