UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Qyz57LRr87i8bD16rd7anrd4I2tO47Wut4ojOjyHTxQ=' 
WHERE 
  key_id = '3794961876124ea9bc15b68ba86f6db9febe7520b2f7f9226fdd01f3ef426615' 
  AND (
    token = 'Qyz57LRr87i8bD16rd7anrd4I2tO47Wut4ojOjyHTxQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027