UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1famIBp2qt8iQvrDtYSCpOqMAlWRS8w6mGSf56ONho='
WHERE
key_id = '0ef82c142fdc90c88a2d632136806bfe80f632bec39fd5544a456bcf1d2fa5f9'
AND (
token = 'r1famIBp2qt8iQvrDtYSCpOqMAlWRS8w6mGSf56ONho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)