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

Query time 0.00021