UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QJgN3shbYxhtll1x2hwy79VBJ2U5op7sU4BnfmIjxDU=' 
WHERE 
  key_id = '3b1d4c5ffe74e7308cb18d80bbb1706bbc5a0b422165b6ae9390d80a81d69e0f' 
  AND (
    token = 'QJgN3shbYxhtll1x2hwy79VBJ2U5op7sU4BnfmIjxDU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025