UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9p37X4qSF88msla1ChwQX7k4QJFlUy8PUnZ1g3b1Uwk=' 
WHERE 
  key_id = '2b8788c29324d14f7aecc8a38e83ee5e41f754a991c5503c06ff04b9d1184b8c' 
  AND (
    token = '9p37X4qSF88msla1ChwQX7k4QJFlUy8PUnZ1g3b1Uwk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026