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