UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1MTy2rOO4YEf/P7VyQMJTw1M+maLPjrg/mC5wSi484='
WHERE
key_id = 'c99e79a9a6f971e99e40279d1dd986532c2f12df5b627a648b1c941bb7d04014'
AND (
token = 'a1MTy2rOO4YEf/P7VyQMJTw1M+maLPjrg/mC5wSi484='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)