UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxCnX0oMz0A8qMm70k36j48xRFY5igpBP13Yc9xzD3k='
WHERE
key_id = '385bcfc9863931da700cc6e035de62321a10bd9aaeaa5c432b2ea54fe2710ce0'
AND (
token = 'sxCnX0oMz0A8qMm70k36j48xRFY5igpBP13Yc9xzD3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)