UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xPsl4ZnxYjiDbg35kI4PR9xiw6tjzxIRR9d8GqxebPk=' 
WHERE 
  key_id = '385a892591b32b7d636a9bf49811cc609aa895a50c80a95a5a557a5b0918ebf2' 
  AND (
    token = 'xPsl4ZnxYjiDbg35kI4PR9xiw6tjzxIRR9d8GqxebPk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00320