UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8zJL5s3dWk5XSfZgnuEv84ZgTxPyxw2JAJ+ZQU9IfXU=' 
WHERE 
  key_id = '8b8853216b4188cae1843a49900d2bafaa912d830318f7a37ade0d713e164ef9' 
  AND (
    token = '8zJL5s3dWk5XSfZgnuEv84ZgTxPyxw2JAJ+ZQU9IfXU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026