UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1D/OftIiNNB15BDq2UxhSaVEFeWs+korSfpG3B6vXGQ=' 
WHERE 
  key_id = '3e24ead0c8b6a47f70e0f3ad24cf72f29cb7f85e8500bd010c9a62d5a03bfe76' 
  AND (
    token = '1D/OftIiNNB15BDq2UxhSaVEFeWs+korSfpG3B6vXGQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019