UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCFLM4Zc54TgPuV21kw9RzrIoYqCXCwiQY3j4J9K9ig='
WHERE
key_id = 'ba5dcd15bbc37350276a07eda6b71ea40f6ef3f3ecccd2cff251c070567e464a'
AND (
token = 'bCFLM4Zc54TgPuV21kw9RzrIoYqCXCwiQY3j4J9K9ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)