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

Query time 0.00036