UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ERZFB0z2X2lWqF4oFG5TQFY3W02qazpnUBWjH6okfVg=' 
WHERE 
  key_id = '51990b39a3ee989f4ae7e5753690879b1f3739f86f97892c44ff3c7fdef4b845' 
  AND (
    token = 'ERZFB0z2X2lWqF4oFG5TQFY3W02qazpnUBWjH6okfVg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043