UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g173YThAxQcoHPBhq5pPgeOidvKSRkitbyV9syrOyuk='
WHERE
key_id = '74a42b709be7254ebb03a842d19fc2f60bbf8d01a4ffd92b0578aa516f6ba645'
AND (
token = 'g173YThAxQcoHPBhq5pPgeOidvKSRkitbyV9syrOyuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)