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

Query time 0.00026