UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g/aCQLIWOm66pao2QItGlWGhXiJO0TSf1oHFZ+mn5gc='
WHERE
key_id = 'b06a083b09927483bea72ae44de1de94bb899b5efcabb3362458ab36a8169ffc'
AND (
token = 'g/aCQLIWOm66pao2QItGlWGhXiJO0TSf1oHFZ+mn5gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)