UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cr1FW8OxYmPd9ueE2lLhMs3Zb588R1dy6v4PI5rgko8='
WHERE
key_id = '6cbaaddf250756026bf7914661f42a07fc31247864669b296e5d20e446729291'
AND (
token = 'Cr1FW8OxYmPd9ueE2lLhMs3Zb588R1dy6v4PI5rgko8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)