UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IxzEoZq4PuK6G0EY3bck7NQzCztFWEDLVtmsUfxZmOI='
WHERE
key_id = 'e0717f9a1cc72d65dff017897b5d45b19fff437dfcc2c3cb1eb6c709f18b33fd'
AND (
token = 'IxzEoZq4PuK6G0EY3bck7NQzCztFWEDLVtmsUfxZmOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)