UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z390SI7IqH/MpdlpO4BJOZhkz8N4vl1HH9hJwyWMVuY=' 
WHERE 
  key_id = 'adb082762131c6f9cc1110c7232e68624d82b8e5dbc2b5476cc92a2ff4bd2640' 
  AND (
    token = 'Z390SI7IqH/MpdlpO4BJOZhkz8N4vl1HH9hJwyWMVuY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022