UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSrKnkHqp3scVigfhZawQahA62XMrwCC8YSuugjGbeo='
WHERE
key_id = '35c6cd07f4ecf78d3741def025e94a3086fad2354b1ff995120207a4ce313447'
AND (
token = 'zSrKnkHqp3scVigfhZawQahA62XMrwCC8YSuugjGbeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)