UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tnNc10TbEZxQ3k1gVL4Tw85XU+P1PJqUww73LQZyxTg=' 
WHERE 
  key_id = 'c1540b4b4e527c09f7214df04f4c91de9f37685028e7b6d322665c1792319be4' 
  AND (
    token = 'tnNc10TbEZxQ3k1gVL4Tw85XU+P1PJqUww73LQZyxTg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020