UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'i+9d/+8Xrny0QNK6bONyUDKF1IZz/GJjHkAITtG9FdQ=' 
WHERE 
  key_id = 'f53918d46897d47747d349306c7c92fe22bfee8ae065767038ac8a0e9b255f39' 
  AND (
    token = 'i+9d/+8Xrny0QNK6bONyUDKF1IZz/GJjHkAITtG9FdQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048