UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7FM6o/fsf+Pz1u0lAHQq6FFc5NyOWfDiaKvtfG2ZWX8=' 
WHERE 
  key_id = 'ec9668dcbb8dd41576b2c4ddfd9f05c2ed06e0a59a39411552348659bf307757' 
  AND (
    token = '7FM6o/fsf+Pz1u0lAHQq6FFc5NyOWfDiaKvtfG2ZWX8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024