UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brX23sqQeImcRMYOxHXE0NWsubCtp6VukKEeoNKoDQg='
WHERE
key_id = '417114dbc797e07d886bd8d30e4bc7e6bdafc85f7222f342e6f925f060a73361'
AND (
token = 'brX23sqQeImcRMYOxHXE0NWsubCtp6VukKEeoNKoDQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)